ANmaFilter3

Filter database into new sheet, by copying certain columns only, not whole ...

ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

ANmaSQL_UpdateDateStatement

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

CreateUniqueList

Create list of unique items from a column into another column This is similar ...

GetColumnIndex

Returns Id of column (Column Index) from a cell. Similar to GetColumnName, this ...

Row_PixelLocation

Gets the cell row where a certain shape is located by passing shape.Top number ...

Hiding chart in Excel

How to hide a full chart in Excel. By treating it as shape, not as chart.

ConcaUFO_RowsfromSheets

Imports rows from multiple sheets of a workbook into final sheet along with ...

Graphbar

Interactive graph bars, will go deeper when you click on the bar Originally ...

GraphBars.zip

CreateList_Matching

Creates list of items found in rows, where these rows match a value in another ...

Column2AnString_Unique

Creates list of unique items found in a column, returns string with items ...